<Schema>
  <Table TableName="Orders" IsView="false" EntityName="Orders">
    <Column ColumnName="OrderID" PropertyName="OrderID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="CustomerID" PropertyName="CustomerID" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nchar(5)" Nullable="true" MaxLength="5" />
    <Column ColumnName="EmployeeID" PropertyName="EmployeeID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int" Nullable="true" Precision="10" Scale="0" />
    <Column ColumnName="OrderDate" PropertyName="OrderDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="RequiredDate" PropertyName="RequiredDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="ShippedDate" PropertyName="ShippedDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="ShipVia" PropertyName="ShipVia" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int" Nullable="true" Precision="10" Scale="0" />
    <Column ColumnName="Freight" PropertyName="Freight" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
    <Column ColumnName="ShipName" PropertyName="ShipName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40)" Nullable="true" MaxLength="40" />
    <Column ColumnName="ShipAddress" PropertyName="ShipAddress" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(60)" Nullable="true" MaxLength="60" />
    <Column ColumnName="ShipCity" PropertyName="ShipCity" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="ShipRegion" PropertyName="ShipRegion" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="ShipPostalCode" PropertyName="ShipPostalCode" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(10)" Nullable="true" MaxLength="10" />
    <Column ColumnName="ShipCountry" PropertyName="ShipCountry" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Association AssociationName="FK_Orders_Customers" PropertyName="Customers" TableName="Orders" ColumnName="CustomerID" RelatedTableName="Customers" RelatedColumnName="CustomerID" />
    <Association AssociationName="FK_Orders_Employees" PropertyName="Employees" TableName="Orders" ColumnName="EmployeeID" RelatedTableName="Employees" RelatedColumnName="EmployeeID" />
    <Association AssociationName="FK_Orders_Shippers" PropertyName="Shippers" TableName="Orders" ColumnName="ShipVia" RelatedTableName="Shippers" RelatedColumnName="ShipperID" />
    <Association AssociationName="FK_Order_Details_OrdersList" PropertyName="Order_Details" TableName="Orders" ColumnName="OrderID" RelatedTableName="Order Details" RelatedColumnName="OrderID" />
  </Table>
  <Table TableName="Products" IsView="false" EntityName="Products">
    <Column ColumnName="ProductID" PropertyName="ProductID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="ProductName" PropertyName="ProductName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="SupplierID" PropertyName="SupplierID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int" Nullable="true" Precision="10" Scale="0" />
    <Column ColumnName="CategoryID" PropertyName="CategoryID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int" Nullable="true" Precision="10" Scale="0" />
    <Column ColumnName="QuantityPerUnit" PropertyName="QuantityPerUnit" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(20)" Nullable="true" MaxLength="20" />
    <Column ColumnName="UnitPrice" PropertyName="UnitPrice" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
    <Column ColumnName="UnitsInStock" PropertyName="UnitsInStock" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint" Nullable="true" Precision="5" Scale="0" />
    <Column ColumnName="UnitsOnOrder" PropertyName="UnitsOnOrder" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint" Nullable="true" Precision="5" Scale="0" />
    <Column ColumnName="ReorderLevel" PropertyName="ReorderLevel" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint" Nullable="true" Precision="5" Scale="0" />
    <Column ColumnName="Discontinued" PropertyName="Discontinued" PropertyType="System.Boolean" PrimaryKey="false" Generated="false" DbType="bit NOT NULL" Nullable="false" />
    <Association AssociationName="FK_Products_Suppliers" PropertyName="Suppliers" TableName="Products" ColumnName="SupplierID" RelatedTableName="Suppliers" RelatedColumnName="SupplierID" />
    <Association AssociationName="FK_Products_Categories" PropertyName="Categories" TableName="Products" ColumnName="CategoryID" RelatedTableName="Categories" RelatedColumnName="CategoryID" />
    <Association AssociationName="FK_Order_Details_ProductsList" PropertyName="Order_Details" TableName="Products" ColumnName="ProductID" RelatedTableName="Order Details" RelatedColumnName="ProductID" />
  </Table>
  <Table TableName="Order Details" IsView="false" EntityName="Order_Details">
    <Column ColumnName="OrderID" PropertyName="OrderID" PropertyType="System.Int32" PrimaryKey="true" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="ProductID" PropertyName="ProductID" PropertyType="System.Int32" PrimaryKey="true" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="UnitPrice" PropertyName="UnitPrice" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money NOT NULL" Nullable="false" Precision="19" Scale="4" />
    <Column ColumnName="Quantity" PropertyName="Quantity" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint NOT NULL" Nullable="false" Precision="5" Scale="0" />
    <Column ColumnName="Discount" PropertyName="Discount" PropertyType="System.Single" PrimaryKey="false" Generated="false" DbType="real NOT NULL" Nullable="false" Precision="24" />
    <Association AssociationName="FK_Order_Details_Orders" PropertyName="Orders" TableName="Order Details" ColumnName="OrderID" RelatedTableName="Orders" RelatedColumnName="OrderID" />
    <Association AssociationName="FK_Order_Details_Products" PropertyName="Products" TableName="Order Details" ColumnName="ProductID" RelatedTableName="Products" RelatedColumnName="ProductID" />
  </Table>
  <Table TableName="Customer and Suppliers by City" IsView="true" EntityName="Customer_and_Suppliers_by_City">
    <Column ColumnName="City" PropertyName="City" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="CompanyName" PropertyName="CompanyName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="ContactName" PropertyName="ContactName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(30)" Nullable="true" MaxLength="30" />
    <Column ColumnName="Relationship" PropertyName="Relationship" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="varchar(9) NOT NULL" Nullable="false" MaxLength="9" />
  </Table>
  <Table TableName="Alphabetical list of products" IsView="true" EntityName="Alphabetical_list_of_products">
    <Column ColumnName="ProductID" PropertyName="ProductID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="ProductName" PropertyName="ProductName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="SupplierID" PropertyName="SupplierID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int" Nullable="true" Precision="10" Scale="0" />
    <Column ColumnName="CategoryID" PropertyName="CategoryID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int" Nullable="true" Precision="10" Scale="0" />
    <Column ColumnName="QuantityPerUnit" PropertyName="QuantityPerUnit" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(20)" Nullable="true" MaxLength="20" />
    <Column ColumnName="UnitPrice" PropertyName="UnitPrice" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
    <Column ColumnName="UnitsInStock" PropertyName="UnitsInStock" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint" Nullable="true" Precision="5" Scale="0" />
    <Column ColumnName="UnitsOnOrder" PropertyName="UnitsOnOrder" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint" Nullable="true" Precision="5" Scale="0" />
    <Column ColumnName="ReorderLevel" PropertyName="ReorderLevel" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint" Nullable="true" Precision="5" Scale="0" />
    <Column ColumnName="Discontinued" PropertyName="Discontinued" PropertyType="System.Boolean" PrimaryKey="false" Generated="false" DbType="bit NOT NULL" Nullable="false" />
    <Column ColumnName="CategoryName" PropertyName="CategoryName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15) NOT NULL" Nullable="false" MaxLength="15" />
  </Table>
  <Table TableName="Current Product List" IsView="true" EntityName="Current_Product_List">
    <Column ColumnName="ProductID" PropertyName="ProductID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="ProductName" PropertyName="ProductName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
  </Table>
  <Table TableName="Orders Qry" IsView="true" EntityName="Orders_Qry">
    <Column ColumnName="OrderID" PropertyName="OrderID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="CustomerID" PropertyName="CustomerID" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nchar(5)" Nullable="true" MaxLength="5" />
    <Column ColumnName="EmployeeID" PropertyName="EmployeeID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int" Nullable="true" Precision="10" Scale="0" />
    <Column ColumnName="OrderDate" PropertyName="OrderDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="RequiredDate" PropertyName="RequiredDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="ShippedDate" PropertyName="ShippedDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="ShipVia" PropertyName="ShipVia" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int" Nullable="true" Precision="10" Scale="0" />
    <Column ColumnName="Freight" PropertyName="Freight" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
    <Column ColumnName="ShipName" PropertyName="ShipName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40)" Nullable="true" MaxLength="40" />
    <Column ColumnName="ShipAddress" PropertyName="ShipAddress" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(60)" Nullable="true" MaxLength="60" />
    <Column ColumnName="ShipCity" PropertyName="ShipCity" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="ShipRegion" PropertyName="ShipRegion" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="ShipPostalCode" PropertyName="ShipPostalCode" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(10)" Nullable="true" MaxLength="10" />
    <Column ColumnName="ShipCountry" PropertyName="ShipCountry" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="CompanyName" PropertyName="CompanyName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="Address" PropertyName="Address" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(60)" Nullable="true" MaxLength="60" />
    <Column ColumnName="City" PropertyName="City" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="Region" PropertyName="Region" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="PostalCode" PropertyName="PostalCode" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(10)" Nullable="true" MaxLength="10" />
    <Column ColumnName="Country" PropertyName="Country" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
  </Table>
  <Table TableName="Products Above Average Price" IsView="true" EntityName="Products_Above_Average_Price">
    <Column ColumnName="ProductName" PropertyName="ProductName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="UnitPrice" PropertyName="UnitPrice" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
  </Table>
  <Table TableName="Products by Category" IsView="true" EntityName="Products_by_Category">
    <Column ColumnName="CategoryName" PropertyName="CategoryName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15) NOT NULL" Nullable="false" MaxLength="15" />
    <Column ColumnName="ProductName" PropertyName="ProductName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="QuantityPerUnit" PropertyName="QuantityPerUnit" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(20)" Nullable="true" MaxLength="20" />
    <Column ColumnName="UnitsInStock" PropertyName="UnitsInStock" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint" Nullable="true" Precision="5" Scale="0" />
    <Column ColumnName="Discontinued" PropertyName="Discontinued" PropertyType="System.Boolean" PrimaryKey="false" Generated="false" DbType="bit NOT NULL" Nullable="false" />
  </Table>
  <Table TableName="Quarterly Orders" IsView="true" EntityName="Quarterly_Orders">
    <Column ColumnName="CustomerID" PropertyName="CustomerID" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nchar(5)" Nullable="true" MaxLength="5" />
    <Column ColumnName="CompanyName" PropertyName="CompanyName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40)" Nullable="true" MaxLength="40" />
    <Column ColumnName="City" PropertyName="City" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="Country" PropertyName="Country" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
  </Table>
  <Table TableName="Invoices" IsView="true" EntityName="Invoices">
    <Column ColumnName="ShipName" PropertyName="ShipName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40)" Nullable="true" MaxLength="40" />
    <Column ColumnName="ShipAddress" PropertyName="ShipAddress" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(60)" Nullable="true" MaxLength="60" />
    <Column ColumnName="ShipCity" PropertyName="ShipCity" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="ShipRegion" PropertyName="ShipRegion" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="ShipPostalCode" PropertyName="ShipPostalCode" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(10)" Nullable="true" MaxLength="10" />
    <Column ColumnName="ShipCountry" PropertyName="ShipCountry" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="CustomerID" PropertyName="CustomerID" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nchar(5)" Nullable="true" MaxLength="5" />
    <Column ColumnName="CustomerName" PropertyName="CustomerName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="Address" PropertyName="Address" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(60)" Nullable="true" MaxLength="60" />
    <Column ColumnName="City" PropertyName="City" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="Region" PropertyName="Region" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="PostalCode" PropertyName="PostalCode" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(10)" Nullable="true" MaxLength="10" />
    <Column ColumnName="Country" PropertyName="Country" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="Salesperson" PropertyName="Salesperson" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(31) NOT NULL" Nullable="false" MaxLength="31" />
    <Column ColumnName="OrderID" PropertyName="OrderID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="OrderDate" PropertyName="OrderDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="RequiredDate" PropertyName="RequiredDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="ShippedDate" PropertyName="ShippedDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="ShipperName" PropertyName="ShipperName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="ProductID" PropertyName="ProductID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="ProductName" PropertyName="ProductName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="UnitPrice" PropertyName="UnitPrice" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money NOT NULL" Nullable="false" Precision="19" Scale="4" />
    <Column ColumnName="Quantity" PropertyName="Quantity" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint NOT NULL" Nullable="false" Precision="5" Scale="0" />
    <Column ColumnName="Discount" PropertyName="Discount" PropertyType="System.Single" PrimaryKey="false" Generated="false" DbType="real NOT NULL" Nullable="false" Precision="24" />
    <Column ColumnName="ExtendedPrice" PropertyName="ExtendedPrice" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
    <Column ColumnName="Freight" PropertyName="Freight" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
  </Table>
  <Table TableName="Order Details Extended" IsView="true" EntityName="Order_Details_Extended">
    <Column ColumnName="OrderID" PropertyName="OrderID" PropertyType="System.Int32" PrimaryKey="true" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="ProductID" PropertyName="ProductID" PropertyType="System.Int32" PrimaryKey="true" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="ProductName" PropertyName="ProductName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="UnitPrice" PropertyName="UnitPrice" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money NOT NULL" Nullable="false" Precision="19" Scale="4" />
    <Column ColumnName="Quantity" PropertyName="Quantity" PropertyType="System.Int16" PrimaryKey="false" Generated="false" DbType="smallint NOT NULL" Nullable="false" Precision="5" Scale="0" />
    <Column ColumnName="Discount" PropertyName="Discount" PropertyType="System.Single" PrimaryKey="false" Generated="false" DbType="real NOT NULL" Nullable="false" Precision="24" />
    <Column ColumnName="ExtendedPrice" PropertyName="ExtendedPrice" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
  </Table>
  <Table TableName="Order Subtotals" IsView="true" EntityName="Order_Subtotals">
    <Column ColumnName="OrderID" PropertyName="OrderID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="Subtotal" PropertyName="Subtotal" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
  </Table>
  <Table TableName="Product Sales for 1997" IsView="true" EntityName="Product_Sales_for_1997">
    <Column ColumnName="CategoryName" PropertyName="CategoryName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15) NOT NULL" Nullable="false" MaxLength="15" />
    <Column ColumnName="ProductName" PropertyName="ProductName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="ProductSales" PropertyName="ProductSales" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
  </Table>
  <Table TableName="Category Sales for 1997" IsView="true" EntityName="Category_Sales_for_1997">
    <Column ColumnName="CategoryName" PropertyName="CategoryName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15) NOT NULL" Nullable="false" MaxLength="15" />
    <Column ColumnName="CategorySales" PropertyName="CategorySales" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
  </Table>
  <Table TableName="Sales by Category" IsView="true" EntityName="Sales_by_Category">
    <Column ColumnName="CategoryID" PropertyName="CategoryID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="CategoryName" PropertyName="CategoryName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15) NOT NULL" Nullable="false" MaxLength="15" />
    <Column ColumnName="ProductName" PropertyName="ProductName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="ProductSales" PropertyName="ProductSales" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
  </Table>
  <Table TableName="Sales Totals by Amount" IsView="true" EntityName="Sales_Totals_by_Amount">
    <Column ColumnName="SaleAmount" PropertyName="SaleAmount" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
    <Column ColumnName="OrderID" PropertyName="OrderID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="CompanyName" PropertyName="CompanyName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="ShippedDate" PropertyName="ShippedDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
  </Table>
  <Table TableName="Summary of Sales by Quarter" IsView="true" EntityName="Summary_of_Sales_by_Quarter">
    <Column ColumnName="ShippedDate" PropertyName="ShippedDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="OrderID" PropertyName="OrderID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="Subtotal" PropertyName="Subtotal" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
  </Table>
  <Table TableName="Summary of Sales by Year" IsView="true" EntityName="Summary_of_Sales_by_Year">
    <Column ColumnName="ShippedDate" PropertyName="ShippedDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="OrderID" PropertyName="OrderID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="Subtotal" PropertyName="Subtotal" PropertyType="System.Decimal" PrimaryKey="false" Generated="false" DbType="money" Nullable="true" Precision="19" Scale="4" />
  </Table>
  <Table TableName="CustomerCustomerDemo" IsView="false" EntityName="CustomerCustomerDemo">
    <Column ColumnName="CustomerID" PropertyName="CustomerID" PropertyType="System.String" PrimaryKey="true" Generated="false" DbType="nchar(5) NOT NULL" Nullable="false" MaxLength="5" />
    <Column ColumnName="CustomerTypeID" PropertyName="CustomerTypeID" PropertyType="System.String" PrimaryKey="true" Generated="false" DbType="nchar(10) NOT NULL" Nullable="false" MaxLength="10" />
    <Association AssociationName="FK_CustomerCustomerDemo_Customers" PropertyName="Customers" TableName="CustomerCustomerDemo" ColumnName="CustomerID" RelatedTableName="Customers" RelatedColumnName="CustomerID" />
    <Association AssociationName="FK_CustomerCustomerDemo" PropertyName="CustomerDemographics" TableName="CustomerCustomerDemo" ColumnName="CustomerTypeID" RelatedTableName="CustomerDemographics" RelatedColumnName="CustomerTypeID" />
  </Table>
  <Table TableName="CustomerDemographics" IsView="false" EntityName="CustomerDemographics">
    <Column ColumnName="CustomerTypeID" PropertyName="CustomerTypeID" PropertyType="System.String" PrimaryKey="true" Generated="false" DbType="nchar(10) NOT NULL" Nullable="false" MaxLength="10" />
    <Column ColumnName="CustomerDesc" PropertyName="CustomerDesc" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="ntext" Nullable="true" MaxLength="1073741823" />
    <Association AssociationName="FK_CustomerCustomerDemoList" PropertyName="CustomerCustomerDemo" TableName="CustomerDemographics" ColumnName="CustomerTypeID" RelatedTableName="CustomerCustomerDemo" RelatedColumnName="CustomerTypeID" />
  </Table>
  <Table TableName="Region" IsView="false" EntityName="Region">
    <Column ColumnName="RegionID" PropertyName="RegionID" PropertyType="System.Int32" PrimaryKey="true" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="RegionDescription" PropertyName="RegionDescription" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nchar(50) NOT NULL" Nullable="false" MaxLength="50" />
    <Association AssociationName="FK_Territories_RegionList" PropertyName="Territories" TableName="Region" ColumnName="RegionID" RelatedTableName="Territories" RelatedColumnName="RegionID" />
  </Table>
  <Table TableName="Territories" IsView="false" EntityName="Territories">
    <Column ColumnName="TerritoryID" PropertyName="TerritoryID" PropertyType="System.String" PrimaryKey="true" Generated="false" DbType="nvarchar(20) NOT NULL" Nullable="false" MaxLength="20" />
    <Column ColumnName="TerritoryDescription" PropertyName="TerritoryDescription" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nchar(50) NOT NULL" Nullable="false" MaxLength="50" />
    <Column ColumnName="RegionID" PropertyName="RegionID" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Association AssociationName="FK_Territories_Region" PropertyName="Region" TableName="Territories" ColumnName="RegionID" RelatedTableName="Region" RelatedColumnName="RegionID" />
    <Association AssociationName="FK_EmployeeTerritories_TerritoriesList" PropertyName="EmployeeTerritories" TableName="Territories" ColumnName="TerritoryID" RelatedTableName="EmployeeTerritories" RelatedColumnName="TerritoryID" />
  </Table>
  <Table TableName="EmployeeTerritories" IsView="false" EntityName="EmployeeTerritories">
    <Column ColumnName="EmployeeID" PropertyName="EmployeeID" PropertyType="System.Int32" PrimaryKey="true" Generated="false" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="TerritoryID" PropertyName="TerritoryID" PropertyType="System.String" PrimaryKey="true" Generated="false" DbType="nvarchar(20) NOT NULL" Nullable="false" MaxLength="20" />
    <Association AssociationName="FK_EmployeeTerritories_Employees" PropertyName="Employees" TableName="EmployeeTerritories" ColumnName="EmployeeID" RelatedTableName="Employees" RelatedColumnName="EmployeeID" />
    <Association AssociationName="FK_EmployeeTerritories_Territories" PropertyName="Territories" TableName="EmployeeTerritories" ColumnName="TerritoryID" RelatedTableName="Territories" RelatedColumnName="TerritoryID" />
  </Table>
  <Table TableName="Employees" IsView="false" EntityName="Employees">
    <Column ColumnName="EmployeeID" PropertyName="EmployeeID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="LastName" PropertyName="LastName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(20) NOT NULL" Nullable="false" MaxLength="20" />
    <Column ColumnName="FirstName" PropertyName="FirstName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(10) NOT NULL" Nullable="false" MaxLength="10" />
    <Column ColumnName="Title" PropertyName="Title" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(30)" Nullable="true" MaxLength="30" />
    <Column ColumnName="TitleOfCourtesy" PropertyName="TitleOfCourtesy" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(25)" Nullable="true" MaxLength="25" />
    <Column ColumnName="BirthDate" PropertyName="BirthDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="HireDate" PropertyName="HireDate" PropertyType="System.DateTime" PrimaryKey="false" Generated="false" DbType="datetime" Nullable="true" />
    <Column ColumnName="Address" PropertyName="Address" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(60)" Nullable="true" MaxLength="60" />
    <Column ColumnName="City" PropertyName="City" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="Region" PropertyName="Region" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="PostalCode" PropertyName="PostalCode" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(10)" Nullable="true" MaxLength="10" />
    <Column ColumnName="Country" PropertyName="Country" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="HomePhone" PropertyName="HomePhone" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(24)" Nullable="true" MaxLength="24" />
    <Column ColumnName="Extension" PropertyName="Extension" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(4)" Nullable="true" MaxLength="4" />
    <Column ColumnName="Photo" PropertyName="Photo" PropertyType="System.Byte[]" PrimaryKey="false" Generated="false" DbType="image" Nullable="true" MaxLength="2147483647" />
    <Column ColumnName="Notes" PropertyName="Notes" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="ntext" Nullable="true" MaxLength="1073741823" />
    <Column ColumnName="ReportsTo" PropertyName="ReportsTo" PropertyType="System.Int32" PrimaryKey="false" Generated="false" DbType="int" Nullable="true" Precision="10" Scale="0" />
    <Column ColumnName="PhotoPath" PropertyName="PhotoPath" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(255)" Nullable="true" MaxLength="255" />
    <Association AssociationName="FK_Employees_Employees" PropertyName="Employees" TableName="Employees" ColumnName="ReportsTo" RelatedTableName="Employees" RelatedColumnName="EmployeeID" />
    <Association AssociationName="FK_Orders_EmployeesList" PropertyName="Orders" TableName="Employees" ColumnName="EmployeeID" RelatedTableName="Orders" RelatedColumnName="EmployeeID" />
    <Association AssociationName="FK_EmployeeTerritories_EmployeesList" PropertyName="EmployeeTerritories" TableName="Employees" ColumnName="EmployeeID" RelatedTableName="EmployeeTerritories" RelatedColumnName="EmployeeID" />
    <Association AssociationName="FK_Employees_EmployeesList" PropertyName="Employees1" TableName="Employees" ColumnName="EmployeeID" RelatedTableName="Employees" RelatedColumnName="ReportsTo" />
  </Table>
  <Table TableName="Categories" IsView="false" EntityName="Categories">
    <Column ColumnName="CategoryID" PropertyName="CategoryID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="CategoryName" PropertyName="CategoryName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15) NOT NULL" Nullable="false" MaxLength="15" />
    <Column ColumnName="Description" PropertyName="Description" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="ntext" Nullable="true" MaxLength="1073741823" />
    <Column ColumnName="Picture" PropertyName="Picture" PropertyType="System.Byte[]" PrimaryKey="false" Generated="false" DbType="image" Nullable="true" MaxLength="2147483647" />
    <Association AssociationName="FK_Products_CategoriesList" PropertyName="Products" TableName="Categories" ColumnName="CategoryID" RelatedTableName="Products" RelatedColumnName="CategoryID" />
  </Table>
  <Table TableName="Customers" IsView="false" EntityName="Customers">
    <Column ColumnName="CustomerID" PropertyName="CustomerID" PropertyType="System.String" PrimaryKey="true" Generated="false" DbType="nchar(5) NOT NULL" Nullable="false" MaxLength="5" />
    <Column ColumnName="CompanyName" PropertyName="CompanyName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="ContactName" PropertyName="ContactName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(30)" Nullable="true" MaxLength="30" />
    <Column ColumnName="ContactTitle" PropertyName="ContactTitle" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(30)" Nullable="true" MaxLength="30" />
    <Column ColumnName="Address" PropertyName="Address" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(60)" Nullable="true" MaxLength="60" />
    <Column ColumnName="City" PropertyName="City" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="Region" PropertyName="Region" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="PostalCode" PropertyName="PostalCode" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(10)" Nullable="true" MaxLength="10" />
    <Column ColumnName="Country" PropertyName="Country" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="Phone" PropertyName="Phone" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(24)" Nullable="true" MaxLength="24" />
    <Column ColumnName="Fax" PropertyName="Fax" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(24)" Nullable="true" MaxLength="24" />
    <Association AssociationName="FK_Orders_CustomersList" PropertyName="Orders" TableName="Customers" ColumnName="CustomerID" RelatedTableName="Orders" RelatedColumnName="CustomerID" />
    <Association AssociationName="FK_CustomerCustomerDemo_CustomersList" PropertyName="CustomerCustomerDemo" TableName="Customers" ColumnName="CustomerID" RelatedTableName="CustomerCustomerDemo" RelatedColumnName="CustomerID" />
  </Table>
  <Table TableName="Shippers" IsView="false" EntityName="Shippers">
    <Column ColumnName="ShipperID" PropertyName="ShipperID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="CompanyName" PropertyName="CompanyName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="Phone" PropertyName="Phone" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(24)" Nullable="true" MaxLength="24" />
    <Association AssociationName="FK_Orders_ShippersList" PropertyName="Orders" TableName="Shippers" ColumnName="ShipperID" RelatedTableName="Orders" RelatedColumnName="ShipVia" />
  </Table>
  <Table TableName="Suppliers" IsView="false" EntityName="Suppliers">
    <Column ColumnName="SupplierID" PropertyName="SupplierID" PropertyType="System.Int32" PrimaryKey="true" Generated="true" DbType="int NOT NULL" Nullable="false" Precision="10" Scale="0" />
    <Column ColumnName="CompanyName" PropertyName="CompanyName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(40) NOT NULL" Nullable="false" MaxLength="40" />
    <Column ColumnName="ContactName" PropertyName="ContactName" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(30)" Nullable="true" MaxLength="30" />
    <Column ColumnName="ContactTitle" PropertyName="ContactTitle" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(30)" Nullable="true" MaxLength="30" />
    <Column ColumnName="Address" PropertyName="Address" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(60)" Nullable="true" MaxLength="60" />
    <Column ColumnName="City" PropertyName="City" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="Region" PropertyName="Region" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="PostalCode" PropertyName="PostalCode" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(10)" Nullable="true" MaxLength="10" />
    <Column ColumnName="Country" PropertyName="Country" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(15)" Nullable="true" MaxLength="15" />
    <Column ColumnName="Phone" PropertyName="Phone" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(24)" Nullable="true" MaxLength="24" />
    <Column ColumnName="Fax" PropertyName="Fax" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="nvarchar(24)" Nullable="true" MaxLength="24" />
    <Column ColumnName="HomePage" PropertyName="HomePage" PropertyType="System.String" PrimaryKey="false" Generated="false" DbType="ntext" Nullable="true" MaxLength="1073741823" />
    <Association AssociationName="FK_Products_SuppliersList" PropertyName="Products" TableName="Suppliers" ColumnName="SupplierID" RelatedTableName="Products" RelatedColumnName="SupplierID" />
  </Table>
</Schema>